OpenEuphoria

db_set_caching

include eds.e 
namespace eds 
public function db_set_caching(atom new_setting) 

sets the key cache behavior.

Parameters:

1. integer : 0 will turn of caching, 1 will turn it back on.

Returns:

An integer, the previous setting of the option.

Comments:

Initially, the cache option is turned on. This means that when possible, the keys of a table are kept in RAM rather than read from disk each time db_select_table is called. For most databases, this will improve performance when you have more than one table in it.

When caching is turned off, the current cache contents is totally cleared.

Example 1:

x = db_set_caching(0) -- Turn off key caching.